Release 10.1A: OpenEdge Data Management:
SQL Reference

LOWER

Returns the result of the argument char_expression after converting all the characters to lowercase.

Syntax

LOWER ( char_expression )

Example

This example illustrates the LOWER function:

SELECT * FROM customer WHERE LOWER (last_name) = 'smith' ;

Notes

The argument to the function must be of type CHARACTER.
The result is of type CHARACTER.
If the argument expression evaluates to NULL, the result is NULL.

Compatibility

SQL compatible